How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

Posted by Haroldo on Stack Overflow See other posts from Stack Overflow or by Haroldo
Published on 2010-04-16T14:56:25Z Indexed on 2010/04/16 15:03 UTC
Read the original article Hit count: 167

Filed under:
|

I'm building a simple calendar for holiday cottages to show when they are booked or available.

What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date.

i can see 2 obvious options

  1. Store 'booked' data for every day [more rows]
  2. or, store 'booked' data with 2 columns a start_date and end_date [more processing?]

Which is best or is there another method i'm missing?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php